User interfaces and software reuse in model based software systems

ABSTRACT

In a model based software system, a set of business rules is scanned, and patterns are identified. The patterns are then compared, and similarities identified which indicate that software can be reused in the system. In one embodiment, identifiers of the rules are scanned. In another embodiment, usage patterns are used for designing a middle layer and generating code. In another embodiment of the invention, a data model is generated by capturing data from a user interface for a business document.

RELATED APPLICATIONS

Benefit is claimed under 35 U.S.C. 119(e) to U.S. Provisional Application Ser. No. 60/553,091, entitled “User Interface Driven Data Modeling Approach” by inventor Sundararajan Parthasarathy et al., filed Mar. 15, 2004, which is herein incorporated in its entirety by reference for all purposes.

Benefit is claimed under 35 U.S.C. 119(e) to U.S. Provisional Application Ser. No. 60/553,089, entitled “An Approach to Identify Software Re-Use in a Model Based Software Solution” by inventor Raghuram Devalla et al., filed Mar. 15, 2004, which is herein incorporated in its entirety by reference for all purposes.

Benefit is claimed under 35 U.S.C. 119(e) to U.S. Provisional Application Ser. No. 60/553,088, entitled “A Formal Approach to Design Generation of Multi-tier Applications Using Behavior Patterns” by inventor Rajagopalan Sethuraman et al., filed Mar. 15, 2004, which is herein incorporated in its entirety by reference for all purposes.

FIELD OF INVENTION

The present invention relates to model based software systems, and in particular, user interfaces and the reuse of software in such model based systems.

BACKGROUND OF INVENTION

Model based software solutions involve approaches and implementations in which every significant part of a software development lifecycle is modeled as data and persisted with capabilities that enable a user to perform various steps in the software development lifecycle. This data modeling requires a high level of specialization, and is usually carried out just before the start of coding. The modeled data is persisted and can be used by downstream processes thereby ensuring that all relevant data that is captured by upstream processes are used in downstream processes without any significant loss of information.

The traditional approach to data modeling involves an understanding of the system in its entirety including all the data dependencies between various entities in the system. A schema designer who models data requires detailed information on the various business processes addressed by the system and the various constituents of the system. For example, the designer requires information in terms of the entities that need to be stored in the system and their relationship with other data that are to be stored in the system. The data types and sizes of those entities also need to be stored.

This schema can then be represented diagrammatically and reviewed by functional specialists. As the number of entities increase, their interconnections with other entities also increase thereby increasing the complexity of the schema. A fully represented schematic diagram for a fairly complex system has many interconnections that explain the origin and destination of the relationship lines between entities.

The granularity of data captured in a model based environment depends on the extent that the model is used. For example, if the functional requirements are captured at a very granular level, it will enable a designer to implement these requirements with the exact business logic as envisioned by a requirements engineer.

During a typical modeling process, business logic that is captured at one point in a system is quite often applicable at some other point in the system. However, because of the granularity of the business logic, the set of business rules that may be needed to be reused may not be a single rule but a set of business rules which may form a subset of the business logic implemented elsewhere. Even though these business rules are not reused by the requirements engineer, the design engineer who analyzes them will benefit if he can identify the reuse of business rules across the various actions. Unfortunately, the task of identifying this subset of the huge set of business rules that exist in the business process is time consuming and strenuous. This makes reuse identification a near impossibility for the design engineer.

BRIEF DESCRIPTION OF THE DRAWINGS

FIG. 1 is a flow chart of an embodiment of the invention.

FIG. 2 illustrates a computer system that may be used in connection with the present invention.

DETAILED DESCRIPTION OF EMBODIMENTS

Any software solution is a collection of user interfaces between a user and a repository where the user's data are stored. These interfaces could be displays, reports, and/or devices such as scanners and readers.

Any such interface can be visualized as a business document with a header section that uniquely identifies the business document. A business document further has various sections each of which captures related data at various stages in the lifecycle of the business document. Such business documents also refer to other documents for information relating to certain key data items in the document. These could be references to the external documents or data copied from the relevant business documents.

The usual approach of designing user interfaces is to capture data for an underlying business in various stages. Each stage adds value to the data that has been already captured. At each of these stages the data captured has direct relevance to the business document that has been considered for automation.

In an embodiment of the invention, a user interface will normally have several types of elements. There are single instance user interface elements such as edit controls, check boxes and text areas. There are also multiple instance data sets that reflect the various constituents of the business document. These normally reflect the table of data that is present in the documents, and are incorporated in the user interfaces as grid controls. Also, there are single instance data items that have a predefined list of values of which one can be selected for a particular instance of a business document. These are incorporated in the user interface as Combo Boxes or List controls. Additionally, sets of single instance data items are present as elements, some or all of which could be applicable for the instance of the business document. These can be incorporated as a group of check boxes. There are also non-editable user elements that reflect the various business states in which a document can exist at any point in time. These are typically incorporated as display only controls. And there are links to other user interfaces that reflect the references to other business documents that could be referred to for additional information. These may be incorporated as hyperlinks or command buttons that invoke other user interfaces by passing the required context information. Lastly, there are reference data items that reflect data that are copied from other business documents and are displayed in the user interface. These are incorporated as display only controls in the user interface.

After establishing the methodology of mapping various user elements to probable business documents, the data model is formed for the business document. A business object (BO) represents the business document, and an interface business object (IBO) refers to the business documents from where the information is acquired. Both business objects and interface business objects have data segments that refer to the various sections of business documents and related business documents. Each data segment has a unique identifier which uniquely identifies an instance of data in the data segment. A hierarchy of data segments can also be established. This can be accomplished by specifying a parent segment to each data segment. A data item of a data segment could be owned by the data segment itself or be present as a reference to another interface business object, a data segment, or a data item.

In an embodiment, factors that affect such a business object hierarchy are as follows. First, every collection of related user interfaces will form a business object. Second, every related collection of referred user interfaces will form an interface business object. Third, every section in the user interface is a data segment. Fourth, any list of values is a data segment from an interface business object. Fifth, any display only field that displays data from other collections is not stored as data but refers to the corresponding data in the interface business objects. Recording the corresponding interface business object, segment, and data items will depict such relations.

In another embodiment, a database schema can be derived out of this structure of business objects and interface business objects. The physical representation of this embodiment is as follows. Every data segment is represented as database tables, and each of these tables has a primary key formed by the identifier that is a part of the segment and the identifiers of its parent segments. Foreign keys are identified for any data items that refer to interface business objects. Every data segment of an interface business object can be represented as database views or database stored procedures. The data items of the data segment are columns for the corresponding database tables. The data items of the interface business objects will be the columns of the corresponding database views or the parameters of the database stored procedures used for integration. This embodiment directly attempts to arrive at a fairly comprehensive database schema that can be further refined for any specific database requirements such as audit trail and concurrency control implications. This embodiment provides a direct relationship of the schema to the user interface, an intuitive approach to database design that enables a high level of consistency with the user interface, and a quick first cut schema to facilitate overall understanding of the business functionality.

In another embodiment, every function in the system has a set of business rules, and a group of business rules is associated with a particular action performed by an end user. These groups can be completely or partially used as part of another task. Identifying this set of business rules is the challenge for the design engineer. In this embodiment, there are two categories of reuse. First, there are a set of rules in which their identification markers repeat across other actions. Second, there are a set of rules that, after considering the contents of the business rules, repeat across other actions. In either instance however, the repetition indicates the possibility of reuse.

In an embodiment, each distinct action is considered. For each action, a sequential scan is made from the first business rule to the last business rule. As the scan progresses the system forms a pattern signature that uniquely identifies the business rules encountered so far in the sequence. The result is that at the end of this step each action will have a pattern signature associated with it.

Thereafter, each task is again considered. A scan is made through the pattern signature to identify if any part of the signature occurs in the pattern signature of the other actions. If such an occurrence is made then the subset is identified as a pattern and recorded separately along with its occurrences.

This process is continued for all actions. If in this process a pattern is identified that consists of other patterns, then this pattern hierarchy is also maintained. At the end of this process the system has data in terms of the various patterns and their occurrences.

A designer then analyzes this data, and identifies the best possible reuse(s). There are several points that a designer may consider in this process. First, a designer may want to maximize business rule reuse by selecting a pattern with the maximum size, irrespective of its occurrences. The advantage of this approach is that the designer can identify bigger chunks of business logic that can be implemented across the system. Second, a designer may choose to maximize occurrence reuse by selecting patterns that cover the maximum number of actions. This embodiment permits a designer to reduce design effort by spreading the effort over a greater number of tasks. Since the reuse is high with this embodiment, adequate care could be exercised in designing for such patterns. Third, a designer could maximize the total number of business rules that need not be designed for as a result of pattern reuse. This embodiment ensures that the maximum amount of patterns that can be reused has been extracted thereby reducing the overall design effort.

In several embodiments, various aspects may be considered before finally arriving at the patterns whose reuses are to be adopted. One such consideration is that as a pattern size is reduced, the reuse of that pattern becomes trivial. That is to say, certain business rules repeat in all actions and are trivial in nature. These should be reused only if it gives a significant benefit for the designers. Reusing patterns that have a negligible business rule count could result in a design overhead that would impact the overall size and effectiveness of the solution.

In an embodiment, in the process of identifying the pattern signature, the description of the business rule is considered. First, the white spaces and special characters other than numerical operators are removed. The actions are then analyzed and pattern signatures formed for every action. Then once the pattern signature is formed, the reuse identification process is similar to that of the embodiment of the first approach.

The advantage of this approach is that it relies on the content of the business rule rather than the identifier of the business rule. While in all likelihood this will be a more time consuming process as the operations have to be carried out on the business rule descriptions (rather than just the identifiers), the result may be more effective than that obtained from the other approach (since it is based on the description which by design holds more information). The approach a user adopts depends on the user's needs and the satisfaction level he obtains in analyzing the reuse in each of the approaches. The process flow is illustrated in FIG. 1.

These approaches to identifying reuse in a model based environment have several advantages. First, there is a tremendous saving of time as a majority of the operations described can be automated. Second, the embodiments are highly effective as each and every business rule is analyzed and all the various combinations are identified. Third, there is a significant saving of design effort as patterns identified will result in decreased design effort leading to a reduction in the construction efforts also.

In another embodiment of the invention, a specification repository captures extensive information on the interfaces and sequence of actions that are needed at different layers. This is a humungous task when there is a need to develop and deploy software systems that involve hundreds of business components and/or functions. This embodiment then abstracts interfaces and action sequences based on the expected response of the system. This abstraction is based on the study of different user actions and the expected behavior of the system in response, and also the participating user interface elements. The expected response of the system is captured as a set of specification data for each action.

Each user action is associated with the user interface information that influences the behavior, and each user action is modeled as a different variety of action based on the expected behavior of the system. For example, a user interaction may be modeled as a document fetch type if the action requires that the system take a key element from the user interface and come up with all information pertaining to that particular business document.

In an embodiment, to design the middle tier elements for implementing the system response for a user interaction, the designer specifies the type of user action, the user interface controls that are involved in this action, and the expected behavior of the system. The expected response of the system is specified as binary logic (Yes/No) to a variety of questions (e.g., whether refresh is required, related combo to be filled, etc.) This information is stored in the model. Design generators then use this model information to generate the service interfaces and method interfaces, and invoking back end objects interfaces also, to generate the sequence of these method calls. A facility is provided to override these interfaces to do a dataset reduction of the interface elements of the methods. The design generators take care of passing the appropriate parameters across the different layers.

The salient advantages of this pattern based design are the resulting simplified interface and sequence specifications across layers. This simplified procedure enables the design work to be done by non-specialists who have an understanding of the application. Second, automated plumbing of interfaces across different software artifacts in different layers leads to reduced defects in terms of interface mismatches. Third, there is standardized design across the entire development team leading to better maintainability. This helps reduce the dependency of persons to either enhance the product or fix defects. Fourth, there is reduced time for design specifications leading to better productivity. Since the middle layer design is driven by expected response it does not require any special skills and can be effectively done by a business user also.

FIG. 2 is an overview diagram of a hardware and operating environment in conjunction with which embodiments of the invention may be practiced. The description of FIG. 2 is intended to provide a brief, general description of suitable computer hardware and a suitable computing environment in conjunction with which the invention may be implemented. In some embodiments, the invention is described in the general context of computer-executable instructions, such as program modules, being executed by a computer, such as a personal computer. Generally, program modules include routines, programs, objects, components, data structures, etc., that perform particular tasks or implement particular abstract data types.

Moreover, those skilled in the art will appreciate that the invention may be practiced with other computer system configurations, including hand-held devices, multiprocessor systems, microprocessor-based or programmable consumer electronics, network PCS, minicomputers, mainframe computers, and the like. The invention may also be practiced in distributed computer environments where tasks are performed by I/O remote processing devices that are linked through a communications network. In a distributed computing environment, program modules may be located in both local and remote memory storage devices.

In the embodiment shown in FIG. 2, a hardware and operating environment is provided that is applicable to any of the servers and/or remote clients shown in the other Figure.

As shown in FIG. 2, one embodiment of the hardware and operating environment includes a general purpose computing device in the form of a computer 20 (e.g., a personal computer, workstation, or server), including one or more processing units 21, a system memory 22, and a system bus 23 that operatively couples various system components including the system memory 22 to the processing unit 21. There may be only one or there may be more than one processing unit 21, such that the processor of computer 20 comprises a single central-processing unit (CPU), or a plurality of processing units, commonly referred to as a multiprocessor or parallel-processor environment. In various embodiments, computer 20 is a conventional computer, a distributed computer, or any other type of computer.

The system bus 23 can be any of several types of bus structures including a memory bus or memory controller, a peripheral bus, and a local bus using any of a variety of bus architectures. The system memory can also be referred to as simply the memory, and, in some embodiments, includes read-only memory (ROM) 24 and random-access memory (RAM) 25. A basic input/output system (BIOS) program 26, containing the basic routines that help to transfer information between elements within the computer 20, such as during start-up, may be stored in ROM 24. The computer 20 further includes a hard disk drive 27 for reading from and writing to a hard disk, not shown, a magnetic disk drive 28 for reading from or writing to a removable magnetic disk 29, and an optical disk drive 30 for reading from or writing to a removable optical disk 31 such as a CD ROM or other optical media.

The hard disk drive 27, magnetic disk drive 28, and optical disk drive 30 couple with a hard disk drive interface 32, a magnetic disk drive interface 33, and an optical disk drive interface 34, respectively. The drives and their associated computer-readable media provide non volatile storage of computer-readable instructions, data structures, program modules and other data for the computer 20. It should be appreciated by those skilled in the art that any type of computer-readable media which can store data that is accessible by a computer, such as magnetic cassettes, flash memory cards, digital video disks, Bernoulli cartridges, random access memories (RAMs), read only memories (RON[s), redundant arrays of independent disks (e.g., RAID storage devices) and the like, can be used in the exemplary operating environment.

A plurality of program modules can be stored on the hard disk, magnetic disk 29, optical disk 31, ROM 24, or RAM 25, including an operating system 35, one or more application programs 36, other program modules 37, and program data 38. A plug in containing a security transmission engine for the present invention can be resident on any one or number of these computer-readable media.

A user may enter commands and information into computer 20 through input devices such as a keyboard 40 and pointing device 42. Other input devices (not shown) can include a microphone, joystick, game pad, satellite dish, scanner, or the like. These other input devices are often connected to the processing unit 21 through a serial port interface 46 that is coupled to the system bus 23, but can be connected by other interfaces, such as a parallel port, game port, or a universal serial bus (USB). A monitor 47 or other type of display device can also be connected to the system bus 23 via an interface, such as a video adapter 48. The monitor 40 can display a graphical user interface for the user. In addition to the monitor 40, computers typically include other peripheral output devices (not shown), such as speakers and printers.

The computer 20 may operate in a networked environment using logical connections to one or more remote computers or servers, such as remote computer 49. These logical connections are achieved by a communication device coupled to or a part of the computer 20; the invention is not limited to a particular type of communications device. The remote computer 49 can be another computer, a server, a router, a network PC, a client, a peer device or other common network node, and typically includes many or all of the elements described above I/O relative to the computer 20, although only a memory storage device 50 has been illustrated. The logical connections depicted in FIG. 2 include a local area network (LAN) 51 and/or a wide area network (WAN) 52. Such networking environments are commonplace in office networks, enterprise-wide computer networks, intranets and the internet, which are all types of networks.

When used in a LAN-networking environment, the computer 20 is connected to the LAN 51 through a network interface or adapter 53, which is one type of communications device. In some embodiments, when used in a WAN-networking environment, the computer 20 typically includes a modem 54 (another type of communications device) or any other type of communications device, e.g., a wireless transceiver, for establishing communications over the wide-area network 52, such as the internet. The modem 54, which may be internal or external, is connected to the system bus 23 via the serial port interface 46. In a networked environment, program modules depicted relative to the computer 20 can be stored in the remote memory storage device 50 of remote computer, or server 49. It is appreciated that the network connections shown are exemplary and other means of, and communications devices for, establishing a communications link between the computers may be used including hybrid fiber-coax connections, T1-T3 lines, DSL's, OC-3 and/or OC-12, TCP/IP, microwave, wireless application protocol, and any other electronic media through any suitable switches, routers, outlets and power lines, as the same are known and understood by one of ordinary skill in the art.

In the foregoing detailed description of embodiments of the invention, various features are grouped together in a single embodiment for the purpose of streamlining the disclosure. This method of disclosure is not to be interpreted as reflecting an intention that the claimed embodiments of the invention require more features than are expressly recited in each claim. Rather, as the following claims reflect, inventive subject matter lies in less than all features of a single disclosed embodiment. Thus the following claims are hereby incorporated into the detailed description of embodiments of the invention, with each claim standing on its own as a separate embodiment. It is understood that the above description is intended to be illustrative, and not restrictive. It is intended to cover all alternatives, modifications and equivalents as may be included within the spirit and scope of the invention as defined in the appended claims. Many other embodiments will be apparent to those of skill in the art upon reviewing the above description. The scope of the invention should, therefore, be determined with reference to the appended claims, along with the full scope of equivalents to which such claims are entitled. In the appended claims, the terms “including” and “in which” are used as the plain-English equivalents of the respective terms “comprising” and “wherein,” respectively. Moreover, the terms “first,” “second,” and “third,” etc., are used merely as labels, and are not intended to impose numerical requirements on their objects. 

1. A method comprising: providing a set of business rules for a software system; scanning said set of business rules; forming a first pattern signature based on said scanning; and determining if said pattern signature is present in other portions of said software system.
 2. The method of claim 1, wherein said scanning is sequential.
 3. The method of claim 1, further comprising recording occurrences of said first pattern signature.
 4. The method of claim 1, further comprising identifying a second pattern signature that is a subset of said first pattern signature.
 5. The method of claim 4, further comprising recording a hierarchy of said first pattern signature and said second pattern signature.
 6. The method of claim 1, further comprising forming a set of pattern signatures for said software system.
 7. The method of claim 6, further comprising analyzing said set of pattern signatures; identifying similarities in said set of pattern signatures; and identifying software that can be reused in said system based on said similarities in said pattern signatures.
 8. The method of claim 7, further comprising selecting from said set of pattern signatures a fourth pattern signature with a maximum size, thereby maximizing reuse of said business rules.
 9. The method of claim 7, further comprising selecting a fifth pattern signature covering a maximum number of actions in said software system.
 10. A method comprising: providing a set of business rules for a software system; scanning said set of business rules; extracting descriptions of said set of business rules from said scanning; forming a first pattern signature based on said descriptions of said set of business rules; and determining if said descriptions are present in other portions of said software system.
 11. The method of claim 10, wherein said scanning is sequential.
 12. The method of claim 10, further comprising recording occurrences of said first pattern signature.
 13. The method of claim 10, further comprising identifying a second pattern signature that is a subset of said first pattern signature.
 14. The method of claim 13, further comprising recording a hierarchy of said first pattern signature and said second pattern signature.
 15. The method of claim 10, further comprising forming a set of pattern signatures for said software system.
 16. The method of claim 15, further comprising: analyzing said set of pattern signatures; identifying similarities in said set of pattern signatures; and identifying software that can be reused in said systems based on said similarities in said pattern signatures.
 17. The method of claim 16, further comprising selecting a fourth pattern signature with a maximum size, thereby maximizing reuse of said business rules.
 18. The method of claim 16, further comprising selecting a fifth pattern signature covering a maximum number of actions in said software system.
 19. A method comprising: capturing user interface data from business documents; mapping user interface elements to said business documents, and forming a data model for said business documents; wherein said business documents are represented by business objects; and wherein said business documents from which said interface data is acquired is represented by interface business objects.
 20. The method of claim 19, wherein said business objects and said interface business objects comprise data segments; and further wherein said data segments comprise a hierarchy.
 21. The method of claim 20, wherein said data segments have a data identifier that identifies an instance of data in said data segment.
 22. The method of claim 21, further comprising forming a hierarchy of data segments.
 23. The method of claim 19, wherein said business documents comprise various sections that capture data at various stages in the lifecycle of said business documents.
 24. The method of claim 19, further comprising using said business objects and said interface business objects to derive a database schema, wherein said schema comprises a user interface.
 25. A method comprising: capturing user interface and user action data for a system in a specification repository; abstracting user interface and user action sequences based on an expected response of said system; and capturing said expected response of said system as a set of specification data for each said user action.
 26. The method of claim 25, further comprising: specifying a type of said user action; specifying user interface controls that are involved in said user action; specifying a second expected response of said system; and storing said second expected response into a model.
 27. The method of claim 26, further comprising: using said model to generate service interfaces and method interfaces; and generating a sequence of method calls.
 28. A computer readable medium comprising instructions available thereon for executing a method comprising: receiving a set of business rules for a software system; scanning said set of business rules; forming a first pattern signature based on said scanning; and determining if said pattern signature is present in other portions of said software system.
 29. The computer readable medium of claim 28, wherein said scanning is sequential.
 30. The computer readable medium of claim 28, further comprising instructions for recording occurrences of said first pattern signature.
 31. The computer readable medium of claim 28, further comprising instructions for identifying a second pattern signature that is a subset of said first pattern signature.
 32. The computer readable medium of claim 31, further comprising instructions for recording a hierarchy of said first pattern signature and said second pattern signature.
 33. The computer readable medium of claim 28, further comprising instructions for forming a set of pattern signatures for said software system.
 34. The computer readable medium of claim 33, further comprising instructions for analyzing said set of pattern signatures; identifying similarities in said set of pattern signatures; and identifying software that can be reused in said system based on said similarities in said pattern signatures.
 35. The computer readable medium of claim 34, further comprising instructions for selecting from said set of pattern signatures a fourth pattern signature with a maximum size, thereby maximizing reuse of said business rules.
 36. The computer readable medium of claim 34, further comprising instructions for selecting a fifth pattern signature covering a maximum number of actions in said software system.
 37. A computer readable medium comprising instructions available thereon for executing a method comprising: receiving a set of business rules for a software system; scanning said set of business rules; extracting descriptions of said set of business rules from said scanning; forming a first pattern signature based on said descriptions of said set of business rules; and determining if said descriptions are present in other portions of said software system.
 38. The computer readable medium of claim 37, wherein said scanning is sequential.
 39. The computer readable medium of claim 37, further comprising instructions for recording occurrences of said first pattern signature.
 40. The computer readable medium of claim 37, further comprising instructions for identifying a second pattern signature that is a subset of said first pattern signature.
 41. The computer readable medium of claim 40, further comprising instructions for recording a hierarchy of said first pattern signature and said second pattern signature.
 42. The computer readable medium of claim 37, further comprising instructions for forming a set of pattern signatures for said software system.
 43. The computer readable medium of claim 42, further comprising instructions for analyzing said set of pattern signatures; identifying similarities in said set of pattern signatures; and identifying software that can be reused in said systems based on said similarities in said pattern signatures.
 44. The computer readable medium of claim 43, further comprising instructions for selecting a fourth pattern signature with a maximum size, thereby maximizing reuse of said business rules.
 45. The computer readable medium of claim 43, further comprising instructions for selecting a fifth pattern signature covering a maximum number of actions in said software system.
 46. A computer readable medium comprising instructions available thereon for executing a method comprising: capturing user interface data from business documents; mapping user interface elements to said business documents, and forming a data model for said business documents; wherein said business documents are represented by business objects; and wherein said business documents from which said interface data is acquired is represented by interface business objects.
 47. The computer readable medium of claim 46, wherein said business objects and said interface business objects comprise data segments; and further wherein said data segments comprise a hierarchy.
 48. The computer readable medium of claim 47, wherein said data segments have a data identifier that identifies an instance of data in said data segment.
 49. The computer readable medium of claim 48, further comprising instructions for forming a hierarchy of data segments.
 50. The computer readable medium of claim 46, wherein said business documents comprise various sections that capture data at various stages in the lifecycle of said business documents.
 51. The computer readable medium of claim 46, further comprising instructions for using said business objects and said interface business objects to derive a database schema, wherein said schema comprises a user interface.
 52. A computer readable medium comprising instructions available thereon for executing a method comprising: capturing user interface and user action data for a system in a specification repository; abstracting user interface and user action sequences based on an expected response of said system; and capturing said expected response of said system as a set of specification data for each said user action.
 53. The computer readable medium of claim 52, further comprising instructions for receiving a type of said user action; receiving user interface controls that are involved in said user action; receiving a second expected response of said system; and storing said second expected response into a model.
 54. The computer readable medium of claim 53, further comprising instructions for using said model to generate service interfaces and method interfaces; and generating a sequence of method calls. 